<table class="layui-table">
    <colgroup>
        <col >
        <col >
        <col >
        <col >
        <col >


        <col>
    </colgroup>
    <thead>
    <tr>
        <th>学员总数</th>
        <th>未毕业学生</th>
        <th>领用车辆</th>
        <th>购进物资总额</th>
        <th>支出物资总额</th>
    </tr>
    </thead>
    <tbody>


        <tr>
            <td><? echo count_by_item($table_Prefix."member","coachid = '".$_REQUEST['nid']."'")?></td>
            <td><? echo count_by_item($table_Prefix."member","coachid = '".$_REQUEST['nid']."' and status != '结业'")?></td>
            <td><? echo count_by_item($table_Prefix."rental","borrower = '".$_REQUEST['nid']."' and status = '借出'")?></td>
            <td><? echo  sum_total($table_Prefix."inventory","price","people = '".$_REQUEST['nid']."' and number > '0'")?></td>
            <td><? echo  sum_total($table_Prefix."inventory","price","people = '".$_REQUEST['nid']."' and number < '0'")?></td>

        </tr>

    </tbody>
</table>

